GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > SetArray Method : SetArray(Int32,Int32,Object[,],Boolean) Method |
'Declaration Public Overloads Sub SetArray( _ ByVal row As System.Integer, _ ByVal column As System.Integer, _ ByVal value(,) As System.Object, _ ByVal formula As System.Boolean _ )
'Usage Dim instance As Worksheet Dim row As System.Integer Dim column As System.Integer Dim value() As System.Object Dim formula As System.Boolean instance.SetArray(row, column, value, formula)
object[,] arr; gcSpreadSheet1.ActiveSheet.SetArray(1, 0, new String[,] { { "One", "Two" } }); gcSpreadSheet1.ActiveSheet.SetArray(2, 1, new String[,] { { "Three", "Four" } }, false); arr = gcSpreadSheet1.ActiveSheet.GetArray(1, 0, 3, 2); gcSpreadSheet1.ActiveSheet.Cells[3, 3].Text = "The value of the first element in the array is " + arr.GetValue(0, 0).ToString();
Dim arr(,) As Object GcSpreadSheet1.ActiveSheet.SetArray(1, 0, New String(,) {{"One", "Two"}}) GcSpreadSheet1.ActiveSheet.SetArray(2, 1, New String(,) {{"Three", "Four"}}, False) arr = GcSpreadSheet1.ActiveSheet.GetArray(1, 0, 3, 2) GcSpreadSheet1.ActiveSheet.Cells(3, 3).Text = "The value of the first element in the array is " & arr.GetValue(0, 0).ToString()
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6